{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 实例10：用Python正则表达式从不规则的备注栏获得采购申请单号"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "公司研发部需要常年采购一些新物料，用于新产品开发。每次采购新物料都需要出一份工程采购申请单（EPR：Engineering purchase request），并有一个编号，格式为“EPR-XX-XXXXX”。由于公司的采购系统中没有用于填写EPR编号的栏位，因此采购在系统填单的时候只得填写到备注栏内。备注栏是一个极其不规范的栏位，每个采购员的风格不同，填写方法也是五花八门，比如如下：\n",
    "![](images\\remark.png)\n",
    "工程部需要每天从系统导出这些物料的采购信息，然后用`vlookup`函数跟其内部登记的表格进行匹配，以了解物料交期，制定新产品开发进度。但是这个采购信息表里的EPR编号实在太不规范，很难与自己的记录表匹配，处理起来费时费力。Python正则表达式（规则表达式）可以轻松地处理这类问题，我们只需要设定好规则，可以从一堆乱七八糟的字符串中提取出我们想要的信息。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1224..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1207..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1207..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1214..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1164..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1164..........',\n",
       " '...ASIA PACIFIC PO  CN.120.EPR-14-X1209..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1175..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1220..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1168..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1168..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1168..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1168..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1221..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1221..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1221..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1154..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1154..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1154..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1154..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1161 BUBBLE SHEET,NEW PACKING..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1200 BUBBLE SHEET,NEW PACKING..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1202 BUBBLE SHEET,NEW PACKING..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1156..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1153..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1153..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1153..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1153..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1144..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1225..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1205..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1205..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1191..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1197..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1171..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1172..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1170..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1192..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1192..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1192..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1212..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1198..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1214..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1206..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1206..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1206..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1173..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1162..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1155..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X1129..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X1129..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X1129..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X1129..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1147..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1177..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1140..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1149..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1169..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1142..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1146..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1146..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1203..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1136..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1136..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1159..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1158..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1176..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1179..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1146..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1146..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1145..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1144..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1143..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1141..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1117..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1117..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1117..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1137..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X1066..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X1066..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X1066..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X1066..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1140..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1112..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1112..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1112..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1112..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1112..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1112..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1111..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1141..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1115..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1115..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1115..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1115..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X1115..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1100..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1100..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1100..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1100..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1100..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1100..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1165..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1091..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1091..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1091..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1091..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1091..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1091..........',\n",
       " '...ASIA PACIFIC PO  CN.202.EPR-14-X1084..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1138..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1139..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X932..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1073..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1152..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X1095..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X998..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X998..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X998..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X998..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1119..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1119..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1119..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1119..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1131..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1093..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1103..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1106..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1098..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1092..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1132..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1121..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1099..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1127..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1130..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1130..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1122..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1069..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1128..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1096..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1082..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1126..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1126..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1126..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1126..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1126..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1125..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1126..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1124..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1114..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1114..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1101..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X1064..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1046..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1094..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X1065..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X995..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X995..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X995..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X995..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X995..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X995..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1087..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1081..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1081..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1081..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1047..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1085..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1026..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1026..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1026..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1026..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1026..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1026..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X847..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1104..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1102..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1023..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1029..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X1059..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1041..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1024..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1080..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1088..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1088..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1067..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1067..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1067..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1107..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1037..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1037..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1037..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1079..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1079..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1079..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1079..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1076..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1054..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1054..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1054..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1054..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1052..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1052..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1052..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1052..........',\n",
       " '...ASIA PACIFIC PO  CN.202.EPR-14-X1074..........',\n",
       " '...ASIA PACIFIC PO  CN.202.EPR-14-X1083..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1053..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X917..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X975..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X975..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X975..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X975..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1045..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1045..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1045..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1045..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1044..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1044..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1044..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1044..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X692..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1068..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1038..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1058..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X554..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X554..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X554..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1016..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X960..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X960..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X1075..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X960..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1077..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X1062..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X1062..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1039..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1070..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1070..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1070..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X983..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1015..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1072..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1061..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1033..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1032..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X985..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1063..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1071..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1043..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1043..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1043..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1043..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X993..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1010..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1025..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X999..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X980..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1005..........',\n",
       " '3535...ASIA PACIFIC PO  CN..EPR-14-X1036..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1023..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1001..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1001..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1001..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1028..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X997..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X902..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X902..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X902..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1008..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1008..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X937..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X937..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X937..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X937..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X937..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1007..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1007..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1040..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1031..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1017..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1006..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X996..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X982..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X1022..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X1030..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X1027..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1042..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1019..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1019..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1019..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1019..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1019..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1019..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1013..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1009..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1009..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1009..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1009..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1020..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1021..........',\n",
       " '3535...ASIA PACIFIC PO  CN..EPR-14-X1035..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X981..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1000..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X989..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X973..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X973..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X973..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X560..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X974..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X1002..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X994..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X984..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X945..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X987..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X877..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X875..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X873..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X870..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X948..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X988..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X988..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X990..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X991..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X966..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X966..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X965..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X967..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X942..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X942..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X978..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X971..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X969..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X859 新包装方法泡泡垫SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X861 新包装泡泡垫SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X860 新包装泡泡垫SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X861 新包装泡泡垫SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X931..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X939..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X674/BUBBLE SHEET..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X972..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X878..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X876..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X874..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X871..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X858..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X680..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X682..........',\n",
       " '...ASIA PACIFIC PO  CN.202.EPR-14-X672..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X667..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X791..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X791..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X791..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X791..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X791..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X791..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X949..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X941..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X954..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X954..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X744..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X946..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X946..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X946..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X962..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X962..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X788..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X788..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X788..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X788..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X788..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X940..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X908..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X952..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X857..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X936..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X801..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X801..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X801..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X854 新包装方法卡通箱..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X852 新包装方法卡通箱..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X853 新包装方法卡通箱样板..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X861 新包装方法泡泡垫..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X859 新包装方法泡泡垫..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X860 新包装方法泡泡垫..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X858..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X905..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X930..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X906..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X906..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X887..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X888..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X929..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X893..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X909..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X777..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X777..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X777..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X892..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X928..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X872..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X866..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X866..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X909..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X895..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X895..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X895..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X895..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X895..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X910..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X915..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X915..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X919..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X922..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X922..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X923..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X923..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X627..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X864..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X850..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X850..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X850..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X850..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X863..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X863..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X863..........',\n",
       " '5149...ASIA PACIFIC PO  CN.201.EPR-14-X863..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X924..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X924..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X881..........',\n",
       " '2484...ASIA PACIFIC PO  CN..EPR-14-X903..........',\n",
       " '...ASIA PACIFIC PO  CN.101.EPR-14-X920..........',\n",
       " '...ASIA PACIFIC PO  CN.101.EPR-17-X921..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X882..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X914..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X890..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X781..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X911..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X911..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X911..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X911..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X901..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X894..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X907..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X883..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X880..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X868..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X879..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X865..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X885..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X820..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X770..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X891..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X856..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X756..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X756..........',\n",
       " '2816...ASIA PACIFIC PO  CN..EPR-14-X832..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X830..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X828..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X827..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X824..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X833..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X831..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X829..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X826..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X782..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X620..........',\n",
       " '2816...ASIA PACIFIC PO  CN..EPR-14-X849..........',\n",
       " '2816...ASIA PACIFIC PO  CN..EPR-14-X848..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X825..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X825..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X798..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X364..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X358..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X797..........',\n",
       " '...ASIA PACIFIC PO  CN.101.EPR-14-X884..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X836..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X836..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X836..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X773..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X799..........',\n",
       " '4897...ASIA PACIFIC PO  CN..EPR-14-X845..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X368..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X368..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X368..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X773..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X843..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X741..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X741..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X741..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X741..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X763..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X763..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X695..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X806..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X472..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X795..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X485..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X485..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X485..........',\n",
       " '4763...ASIA PACIFIC PO  CN..EPR-14-X844..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X808..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X808..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X808..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X796..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X796..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X796..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X810..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X810..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X810..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X814..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X819..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X815..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X841..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X813..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X811..........',\n",
       " '4763...ASIA PACIFIC PO  CN..EPR-14-X666..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X786..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X785..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X784..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X805..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X789..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X842..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X842..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X757..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X787..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X787..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X787..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X787..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X698..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X775..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '4658...ASIA PACIFIC PO  CN..EPR-14-X284..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X838..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X838..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X838..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X821..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X821..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X817..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X816..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X822..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X809..........',\n",
       " '3694...ASIA PACIFIC PO  CN.201.EPR-14-X807..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X486..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X713..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X793..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X764..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X794..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X794..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X609..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X609..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X609..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X778..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X803..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X769..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X769..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X769..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X711..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X790..........',\n",
       " '3702...ASIA PACIFIC PO  CN.201.EPR-14-X742..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X780..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X783..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X804..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X768..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X779..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X779..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X779..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X779..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X745..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X751..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X746..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X747..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X774..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X725..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X499..........',\n",
       " '2586...ASIA PACIFIC PO  CN.201.EPR-14?X717..........',\n",
       " '2586...ASIA PACIFIC PO  CN.201.EPR-14?X717..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X407..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X407..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X407..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X407..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X407..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X378..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X378..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X378..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X378..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X378..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X378..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X776..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X766..........',\n",
       " '...ASIA PACIFIC PO  CN.102.EPR-14-X730..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X688..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X688..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14?X650..........',\n",
       " '4508...ASIA PACIFIC PO  CN.201.EPR-14?X772..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X732..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X732..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X732..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X732..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X732..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X732..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X749..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X740..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X740..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X740..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X740..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X760..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X724..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X714..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X765..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X744..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X743..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X715..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X708..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X683..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X762..........',\n",
       " '4756...ASIA PACIFIC PO  CN..EPR-14-X665..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X761..........',\n",
       " '2586...ASIA PACIFIC PO  CN.201.EPR-14-X714..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X667..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X670..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X522..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X750..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X728 INLAX EPRINTING样板..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X704..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X739..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14?X735..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X738..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X736..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X694..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X694..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X694..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X684..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X684..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X700..........',\n",
       " '4523...ASIA PACIFIC PO  CN.201.EPR-14-X677..........',\n",
       " '4523...ASIA PACIFIC PO  CN.201.EPR-14-X677..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X709..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X733..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X734..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X615 ;LCD..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X710..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X698..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X551..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X712..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X614..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X614..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X614..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X614..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X654..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X653..........',\n",
       " '2586...ASIA PACIFIC PO  CN.201.EPR-14-X716..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X703..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X702..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X729..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X706..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X706..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X706..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X706..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X706..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X706..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X695..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X652..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X722..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X624..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X689..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X658..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X658..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X673..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X687..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X686..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X674..........',\n",
       " '...ASIA PACIFIC PO  CN.122.EPR-14-X680..........',\n",
       " '...ASIA PACIFIC PO  CN.122.EPR-14-X682..........',\n",
       " '...ASIA PACIFIC PO  CN.122.EPR-14-X672..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X696..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X696..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X699..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X697..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X697..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X692..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X693..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X693..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X693..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X617..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X617..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X617..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X617..........',\n",
       " 'OOO5278...ASIA PACIFIC PO  CN.201.EPR-14-X617..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '5013...ASIA PACIFIC PO  CN.201.EPR-14-X642..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X657..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X129..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X623..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X623..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X623..........',\n",
       " '...ASIA PACIFIC PO  CN.122.EPR-14-X681..........',\n",
       " '...ASIA PACIFIC PO  CN.122.EPR-14-X679..........',\n",
       " '...ASIA PACIFIC PO  CN.122.EPR-14-X671..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X592..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X656..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X655..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X455..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X691..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X691..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X691..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X691..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X615..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X615..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X615..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X641..........',\n",
       " '4523...ASIA PACIFIC PO  CN.201.EPR-14-X678..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X630..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X669..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X637..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X628..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X602..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X602..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X602..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X602..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X602..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X602..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X640..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X639..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X647..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X647..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X576..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X576..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X540..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X540..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X540..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X540..........',\n",
       " '4897...ASIA PACIFIC PO  CN..EPR-14-X439..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X662..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X634..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X651..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X566..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X624..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X588..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X580..........',\n",
       " '4897...ASIA PACIFIC PO  CN..EPR-14-X660..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X649..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X636..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X638..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X644..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X644..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X646..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X646..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X585..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X635..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X599..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X599..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X569..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X498..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X632..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X643..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X595..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X605..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X619..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X611..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X600..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X579..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X613..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X612..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X564..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X555..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X591..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X535..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X631..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X598..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X526..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X584..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X607..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X559..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X557..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X553..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X581..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X581..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X581..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X596..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X596..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X596..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X596..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X601..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X575..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X589 RUBBER SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X589 RUBBER SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X589 RUBBER SAMPLE..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X552..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X590..........',\n",
       " 'OOO5309...ASIA PACIFIC PO  CN..EPR-14-X204..........',\n",
       " 'OOO5309...ASIA PACIFIC PO  CN..EPR-14-X204..........',\n",
       " '4132...ASIA PACIFIC PO  CN..EPR-14-X476..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X542..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X543..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X367..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X577..........',\n",
       " '4897...ASIA PACIFIC PO  CN..EPR-14-X439..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X603..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X604..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X594..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X388..........',\n",
       " '4998...ASIA PACIFIC PO  CN..EPR-14-X388..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X517..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X517..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X525..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X524..........',\n",
       " '4438...ASIA PACIFIC PO  CN.201.EPR-14-X524..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X587..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X530..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X573..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X539..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X539..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X539..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X560..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X558..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X554..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X554..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X570..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X541..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X538..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X538..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X538..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X536..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X536..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X534..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X333..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X546..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X546..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X546..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X546..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X546..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X546..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X545..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X541..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X534..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X538..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X538..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X538..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X528..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X532..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X532..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X532..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X515..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X547..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X547..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X547..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X547..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X514..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X523..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X523..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X548..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X522..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X522..........',\n",
       " '4953...ASIA PACIFIC PO  CN.201.EPR-14-X513..........',\n",
       " '4953...ASIA PACIFIC PO  CN.201.EPR-14-X512..........',\n",
       " '4897...ASIA PACIFIC PO  CN..EPR-14-X451..........',\n",
       " '4897...ASIA PACIFIC PO  CN..EPR-14-X439..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X556..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X516..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X519..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X508..........',\n",
       " '...ASIA PACIFIC PO  CN.201.EPR-14-X531..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X529..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X529..........',\n",
       " 'OOO5620...ASIA PACIFIC PO  CN..EPR-14-X549..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X464..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X457..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X448..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X293..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X521..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X521..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X509..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X550..........',\n",
       " 'OOO5372...ASIA PACIFIC PO  CN.201.EPR-14-X511..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X510..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X430..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X491..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X459..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X504..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X500..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X520..........',\n",
       " '...ASIA PACIFIC PO  CN..EPR-14-X484..........',\n",
       " ...]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#1.获取备注栏的所有信息\n",
    "from openpyxl import load_workbook\n",
    "wb=load_workbook(\"data\\采购信息表.xlsx\")\n",
    "ws=wb['Sheet1']\n",
    "PR_rawdata=[]\n",
    "for row in range(2,ws.max_row+1):\n",
    "    PR_rawdata.append(ws.cell(row=row,column=4).value)\n",
    "PR_rawdata"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "首先，我们导入`openpyxl`模块的`load_workbook`方法打开“采购信息表”，获取“Sheet1”工作表。然后建立一个空列表`PR_rawdata`，以存储备注栏对应列的信息。随后从第二行开始遍历所有行，提取第四列中的信息，使用`append`方法将其存入空列表`PR_rawdata`。\n",
    "\n",
    "提取完信息后，可通过`len()`查看`PR_rawdata`中元素个数，看看是否有遗漏。我们可以看到有1583个元素，妥妥的。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1583"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(PR_rawdata)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "#2.使用正则表达式获取PR编号\n",
    "from re import compile, IGNORECASE\n",
    "def get_EPR_num(text):\n",
    "    #将问号'?' 替换成 '-'\n",
    "    changed_question_mark = text.replace(\"?\",\"-\")\n",
    "    #获取EPR编号\n",
    "    epr_num = compile(r'EPR-\\d{2}-X\\d{3}(\\d)?',IGNORECASE)\n",
    "    match = epr_num.search(changed_question_mark)\n",
    "    #将小写EPR转换为大写并返回\n",
    "    return match.group().upper()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "然后我们就开始使用强大的正则表达式。首先导入`re`模块中的`compile`及`IGNORECASE`。`re`模块包含正则表达式的所有函数。`compile`为正则表达式函数，用于匹配所需要的内容；`IGNORECASE`表示忽略字符串中的大小写。我们先创建一个函数`get_EPR_num()`，以方便后面反复调用，其中包含一个参数`text`，用于传入包含EPR编号的字符串，比如“...ASIA PACIFIC PO  CN..EPR-14?X1059..........”。函数要做的事，就是在这个字符串中按照我们设定的规则提取出EPR编号，其结果应该是“EPR-14-X1059”。\n",
    "\n",
    "有些包含EPR编号的字符串是带有问号“?”的，比如“EPR-14?X1059”，因此需要先将其替换成我们想要的“-”。我们使用`replace(\"?\",\"-\")`进行替换。然后向`compile`中传入一个字符串r“\\S{3}-\\d\\d\\S\\S\\d{3}(\\d)?”，创建正则表达式，并增加参数`IGNORECASE`忽略大小写。最前面的`r`表示忽略字符串中的转义字符（此例中的“\\”是正则表达式规则的一部分，不是转义字符，若不忽略，将被程序当成转义字符而出错）。其中\"\\S\"指除空格外的所有字符，“{3}”指匹配三次。然后是“-”，接着是两个数字“\\d{2}”。“-X”之后3或4个数字，所以用“\\d{3}(\\d)?”，其中“(\\d)?”表示可选匹配，即“-X”后面是3位数字的话就取3位数字，是4位数字就取4位数字。\n",
    "\n",
    "正则表达式创建好后，我们就去到原始字符串中去搜索符合条件的项，并存入`match`变量。最后调用Match对象的group()方法，并使用upper()将小写转换为大写，返回匹配到的字符串，即EPR编号。group()是可以截取分组的字符串，分组是通过在正则表达式中加入括号()来操作，此例未分组，即只有1组。正则表达式常用的符号如下：\n",
    "![](images\\reg.png)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['EPR-14-X1224',\n",
       " 'EPR-14-X1224',\n",
       " 'EPR-14-X1224',\n",
       " 'EPR-14-X1224',\n",
       " 'EPR-14-X1224',\n",
       " 'EPR-14-X1224',\n",
       " 'EPR-14-X1224',\n",
       " 'EPR-14-X1207',\n",
       " 'EPR-14-X1207',\n",
       " 'EPR-14-X1214',\n",
       " 'EPR-14-X1164',\n",
       " 'EPR-14-X1164',\n",
       " 'EPR-14-X1209',\n",
       " 'EPR-14-X1175',\n",
       " 'EPR-14-X1220',\n",
       " 'EPR-14-X1168',\n",
       " 'EPR-14-X1168',\n",
       " 'EPR-14-X1168',\n",
       " 'EPR-14-X1168',\n",
       " 'EPR-14-X1221',\n",
       " 'EPR-14-X1221',\n",
       " 'EPR-14-X1221',\n",
       " 'EPR-14-X1154',\n",
       " 'EPR-14-X1154',\n",
       " 'EPR-14-X1154',\n",
       " 'EPR-14-X1154',\n",
       " 'EPR-14-X1161',\n",
       " 'EPR-14-X1200',\n",
       " 'EPR-14-X1202',\n",
       " 'EPR-14-X1156',\n",
       " 'EPR-14-X1153',\n",
       " 'EPR-14-X1153',\n",
       " 'EPR-14-X1153',\n",
       " 'EPR-14-X1153',\n",
       " 'EPR-14-X1144',\n",
       " 'EPR-14-X1225',\n",
       " 'EPR-14-X1205',\n",
       " 'EPR-14-X1205',\n",
       " 'EPR-14-X1191',\n",
       " 'EPR-14-X1197',\n",
       " 'EPR-14-X1171',\n",
       " 'EPR-14-X1172',\n",
       " 'EPR-14-X1170',\n",
       " 'EPR-14-X1192',\n",
       " 'EPR-14-X1192',\n",
       " 'EPR-14-X1192',\n",
       " 'EPR-14-X1212',\n",
       " 'EPR-14-X1198',\n",
       " 'EPR-14-X1214',\n",
       " 'EPR-14-X1206',\n",
       " 'EPR-14-X1206',\n",
       " 'EPR-14-X1206',\n",
       " 'EPR-14-X1173',\n",
       " 'EPR-14-X1162',\n",
       " 'EPR-14-X1155',\n",
       " 'EPR-14-X1129',\n",
       " 'EPR-14-X1129',\n",
       " 'EPR-14-X1129',\n",
       " 'EPR-14-X1129',\n",
       " 'EPR-14-X1147',\n",
       " 'EPR-14-X1177',\n",
       " 'EPR-14-X1140',\n",
       " 'EPR-14-X1149',\n",
       " 'EPR-14-X1169',\n",
       " 'EPR-14-X1142',\n",
       " 'EPR-14-X1146',\n",
       " 'EPR-14-X1146',\n",
       " 'EPR-14-X1203',\n",
       " 'EPR-14-X1136',\n",
       " 'EPR-14-X1136',\n",
       " 'EPR-14-X1159',\n",
       " 'EPR-14-X1158',\n",
       " 'EPR-14-X1176',\n",
       " 'EPR-14-X1179',\n",
       " 'EPR-14-X1146',\n",
       " 'EPR-14-X1146',\n",
       " 'EPR-14-X1145',\n",
       " 'EPR-14-X1144',\n",
       " 'EPR-14-X1143',\n",
       " 'EPR-14-X1141',\n",
       " 'EPR-14-X1117',\n",
       " 'EPR-14-X1117',\n",
       " 'EPR-14-X1117',\n",
       " 'EPR-14-X1137',\n",
       " 'EPR-14-X1066',\n",
       " 'EPR-14-X1066',\n",
       " 'EPR-14-X1066',\n",
       " 'EPR-14-X1066',\n",
       " 'EPR-14-X1140',\n",
       " 'EPR-14-X1112',\n",
       " 'EPR-14-X1112',\n",
       " 'EPR-14-X1112',\n",
       " 'EPR-14-X1112',\n",
       " 'EPR-14-X1112',\n",
       " 'EPR-14-X1112',\n",
       " 'EPR-14-X1111',\n",
       " 'EPR-14-X1141',\n",
       " 'EPR-14-X1115',\n",
       " 'EPR-14-X1115',\n",
       " 'EPR-14-X1115',\n",
       " 'EPR-14-X1115',\n",
       " 'EPR-14-X1115',\n",
       " 'EPR-14-X1100',\n",
       " 'EPR-14-X1100',\n",
       " 'EPR-14-X1100',\n",
       " 'EPR-14-X1100',\n",
       " 'EPR-14-X1100',\n",
       " 'EPR-14-X1100',\n",
       " 'EPR-14-X1165',\n",
       " 'EPR-14-X1091',\n",
       " 'EPR-14-X1091',\n",
       " 'EPR-14-X1091',\n",
       " 'EPR-14-X1091',\n",
       " 'EPR-14-X1091',\n",
       " 'EPR-14-X1091',\n",
       " 'EPR-14-X1084',\n",
       " 'EPR-14-X1138',\n",
       " 'EPR-14-X1139',\n",
       " 'EPR-14-X932',\n",
       " 'EPR-14-X1073',\n",
       " 'EPR-14-X1152',\n",
       " 'EPR-14-X1095',\n",
       " 'EPR-14-X998',\n",
       " 'EPR-14-X998',\n",
       " 'EPR-14-X998',\n",
       " 'EPR-14-X998',\n",
       " 'EPR-14-X1119',\n",
       " 'EPR-14-X1119',\n",
       " 'EPR-14-X1119',\n",
       " 'EPR-14-X1119',\n",
       " 'EPR-14-X1131',\n",
       " 'EPR-14-X1093',\n",
       " 'EPR-14-X1103',\n",
       " 'EPR-14-X1106',\n",
       " 'EPR-14-X1098',\n",
       " 'EPR-14-X1092',\n",
       " 'EPR-14-X1132',\n",
       " 'EPR-14-X1121',\n",
       " 'EPR-14-X1099',\n",
       " 'EPR-14-X1127',\n",
       " 'EPR-14-X1130',\n",
       " 'EPR-14-X1130',\n",
       " 'EPR-14-X1122',\n",
       " 'EPR-14-X1069',\n",
       " 'EPR-14-X1128',\n",
       " 'EPR-14-X1096',\n",
       " 'EPR-14-X1082',\n",
       " 'EPR-14-X1126',\n",
       " 'EPR-14-X1126',\n",
       " 'EPR-14-X1126',\n",
       " 'EPR-14-X1126',\n",
       " 'EPR-14-X1126',\n",
       " 'EPR-14-X1125',\n",
       " 'EPR-14-X1126',\n",
       " 'EPR-14-X1124',\n",
       " 'EPR-14-X1114',\n",
       " 'EPR-14-X1114',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1101',\n",
       " 'EPR-14-X1064',\n",
       " 'EPR-14-X1046',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X1094',\n",
       " 'EPR-14-X1065',\n",
       " 'EPR-14-X995',\n",
       " 'EPR-14-X995',\n",
       " 'EPR-14-X995',\n",
       " 'EPR-14-X995',\n",
       " 'EPR-14-X995',\n",
       " 'EPR-14-X995',\n",
       " 'EPR-14-X1087',\n",
       " 'EPR-14-X1081',\n",
       " 'EPR-14-X1081',\n",
       " 'EPR-14-X1081',\n",
       " 'EPR-14-X1047',\n",
       " 'EPR-14-X1085',\n",
       " 'EPR-14-X1026',\n",
       " 'EPR-14-X1026',\n",
       " 'EPR-14-X1026',\n",
       " 'EPR-14-X1026',\n",
       " 'EPR-14-X1026',\n",
       " 'EPR-14-X1026',\n",
       " 'EPR-14-X847',\n",
       " 'EPR-14-X1104',\n",
       " 'EPR-14-X1102',\n",
       " 'EPR-14-X1023',\n",
       " 'EPR-14-X1029',\n",
       " 'EPR-14-X1059',\n",
       " 'EPR-14-X1041',\n",
       " 'EPR-14-X1024',\n",
       " 'EPR-14-X1080',\n",
       " 'EPR-14-X1088',\n",
       " 'EPR-14-X1088',\n",
       " 'EPR-14-X1067',\n",
       " 'EPR-14-X1067',\n",
       " 'EPR-14-X1067',\n",
       " 'EPR-14-X1107',\n",
       " 'EPR-14-X1037',\n",
       " 'EPR-14-X1037',\n",
       " 'EPR-14-X1037',\n",
       " 'EPR-14-X1079',\n",
       " 'EPR-14-X1079',\n",
       " 'EPR-14-X1079',\n",
       " 'EPR-14-X1079',\n",
       " 'EPR-14-X1076',\n",
       " 'EPR-14-X1054',\n",
       " 'EPR-14-X1054',\n",
       " 'EPR-14-X1054',\n",
       " 'EPR-14-X1054',\n",
       " 'EPR-14-X1052',\n",
       " 'EPR-14-X1052',\n",
       " 'EPR-14-X1052',\n",
       " 'EPR-14-X1052',\n",
       " 'EPR-14-X1074',\n",
       " 'EPR-14-X1083',\n",
       " 'EPR-14-X1053',\n",
       " 'EPR-14-X917',\n",
       " 'EPR-14-X975',\n",
       " 'EPR-14-X975',\n",
       " 'EPR-14-X975',\n",
       " 'EPR-14-X975',\n",
       " 'EPR-14-X1045',\n",
       " 'EPR-14-X1045',\n",
       " 'EPR-14-X1045',\n",
       " 'EPR-14-X1045',\n",
       " 'EPR-14-X1044',\n",
       " 'EPR-14-X1044',\n",
       " 'EPR-14-X1044',\n",
       " 'EPR-14-X1044',\n",
       " 'EPR-14-X692',\n",
       " 'EPR-14-X1068',\n",
       " 'EPR-14-X1038',\n",
       " 'EPR-14-X1058',\n",
       " 'EPR-14-X554',\n",
       " 'EPR-14-X554',\n",
       " 'EPR-14-X554',\n",
       " 'EPR-14-X1016',\n",
       " 'EPR-14-X960',\n",
       " 'EPR-14-X960',\n",
       " 'EPR-14-X1075',\n",
       " 'EPR-14-X960',\n",
       " 'EPR-14-X1077',\n",
       " 'EPR-14-X1062',\n",
       " 'EPR-14-X1062',\n",
       " 'EPR-14-X1039',\n",
       " 'EPR-14-X1070',\n",
       " 'EPR-14-X1070',\n",
       " 'EPR-14-X1070',\n",
       " 'EPR-14-X983',\n",
       " 'EPR-14-X1015',\n",
       " 'EPR-14-X1072',\n",
       " 'EPR-14-X1061',\n",
       " 'EPR-14-X1033',\n",
       " 'EPR-14-X1032',\n",
       " 'EPR-14-X985',\n",
       " 'EPR-14-X1063',\n",
       " 'EPR-14-X1071',\n",
       " 'EPR-14-X1043',\n",
       " 'EPR-14-X1043',\n",
       " 'EPR-14-X1043',\n",
       " 'EPR-14-X1043',\n",
       " 'EPR-14-X993',\n",
       " 'EPR-14-X1010',\n",
       " 'EPR-14-X1025',\n",
       " 'EPR-14-X999',\n",
       " 'EPR-14-X980',\n",
       " 'EPR-14-X1005',\n",
       " 'EPR-14-X1036',\n",
       " 'EPR-14-X1023',\n",
       " 'EPR-14-X1001',\n",
       " 'EPR-14-X1001',\n",
       " 'EPR-14-X1001',\n",
       " 'EPR-14-X1028',\n",
       " 'EPR-14-X997',\n",
       " 'EPR-14-X902',\n",
       " 'EPR-14-X902',\n",
       " 'EPR-14-X902',\n",
       " 'EPR-14-X1008',\n",
       " 'EPR-14-X1008',\n",
       " 'EPR-14-X937',\n",
       " 'EPR-14-X937',\n",
       " 'EPR-14-X937',\n",
       " 'EPR-14-X937',\n",
       " 'EPR-14-X937',\n",
       " 'EPR-14-X1007',\n",
       " 'EPR-14-X1007',\n",
       " 'EPR-14-X1040',\n",
       " 'EPR-14-X1031',\n",
       " 'EPR-14-X1017',\n",
       " 'EPR-14-X1006',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X996',\n",
       " 'EPR-14-X982',\n",
       " 'EPR-14-X1022',\n",
       " 'EPR-14-X1030',\n",
       " 'EPR-14-X1027',\n",
       " 'EPR-14-X1042',\n",
       " 'EPR-14-X1019',\n",
       " 'EPR-14-X1019',\n",
       " 'EPR-14-X1019',\n",
       " 'EPR-14-X1019',\n",
       " 'EPR-14-X1019',\n",
       " 'EPR-14-X1019',\n",
       " 'EPR-14-X1013',\n",
       " 'EPR-14-X1009',\n",
       " 'EPR-14-X1009',\n",
       " 'EPR-14-X1009',\n",
       " 'EPR-14-X1009',\n",
       " 'EPR-14-X1020',\n",
       " 'EPR-14-X1021',\n",
       " 'EPR-14-X1035',\n",
       " 'EPR-14-X981',\n",
       " 'EPR-14-X1000',\n",
       " 'EPR-14-X989',\n",
       " 'EPR-14-X973',\n",
       " 'EPR-14-X973',\n",
       " 'EPR-14-X973',\n",
       " 'EPR-14-X560',\n",
       " 'EPR-14-X974',\n",
       " 'EPR-14-X1002',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X994',\n",
       " 'EPR-14-X984',\n",
       " 'EPR-14-X945',\n",
       " 'EPR-14-X987',\n",
       " 'EPR-14-X877',\n",
       " 'EPR-14-X875',\n",
       " 'EPR-14-X873',\n",
       " 'EPR-14-X870',\n",
       " 'EPR-14-X948',\n",
       " 'EPR-14-X988',\n",
       " 'EPR-14-X988',\n",
       " 'EPR-14-X990',\n",
       " 'EPR-14-X991',\n",
       " 'EPR-14-X966',\n",
       " 'EPR-14-X966',\n",
       " 'EPR-14-X965',\n",
       " 'EPR-14-X967',\n",
       " 'EPR-14-X942',\n",
       " 'EPR-14-X942',\n",
       " 'EPR-14-X978',\n",
       " 'EPR-14-X971',\n",
       " 'EPR-14-X969',\n",
       " 'EPR-14-X859',\n",
       " 'EPR-14-X861',\n",
       " 'EPR-14-X860',\n",
       " 'EPR-14-X861',\n",
       " 'EPR-14-X931',\n",
       " 'EPR-14-X939',\n",
       " 'EPR-14-X674',\n",
       " 'EPR-14-X972',\n",
       " 'EPR-14-X878',\n",
       " 'EPR-14-X876',\n",
       " 'EPR-14-X874',\n",
       " 'EPR-14-X871',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X858',\n",
       " 'EPR-14-X680',\n",
       " 'EPR-14-X682',\n",
       " 'EPR-14-X672',\n",
       " 'EPR-14-X667',\n",
       " 'EPR-14-X791',\n",
       " 'EPR-14-X791',\n",
       " 'EPR-14-X791',\n",
       " 'EPR-14-X791',\n",
       " 'EPR-14-X791',\n",
       " 'EPR-14-X791',\n",
       " 'EPR-14-X949',\n",
       " 'EPR-14-X941',\n",
       " 'EPR-14-X954',\n",
       " 'EPR-14-X954',\n",
       " 'EPR-14-X744',\n",
       " 'EPR-14-X946',\n",
       " 'EPR-14-X946',\n",
       " 'EPR-14-X946',\n",
       " 'EPR-14-X962',\n",
       " 'EPR-14-X962',\n",
       " 'EPR-14-X788',\n",
       " 'EPR-14-X788',\n",
       " 'EPR-14-X788',\n",
       " 'EPR-14-X788',\n",
       " 'EPR-14-X788',\n",
       " 'EPR-14-X940',\n",
       " 'EPR-14-X908',\n",
       " 'EPR-14-X952',\n",
       " 'EPR-14-X857',\n",
       " 'EPR-14-X936',\n",
       " 'EPR-14-X801',\n",
       " 'EPR-14-X801',\n",
       " 'EPR-14-X801',\n",
       " 'EPR-14-X854',\n",
       " 'EPR-14-X852',\n",
       " 'EPR-14-X853',\n",
       " 'EPR-14-X861',\n",
       " 'EPR-14-X859',\n",
       " 'EPR-14-X860',\n",
       " 'EPR-14-X858',\n",
       " 'EPR-14-X905',\n",
       " 'EPR-14-X930',\n",
       " 'EPR-14-X906',\n",
       " 'EPR-14-X906',\n",
       " 'EPR-14-X887',\n",
       " 'EPR-14-X888',\n",
       " 'EPR-14-X929',\n",
       " 'EPR-14-X893',\n",
       " 'EPR-14-X909',\n",
       " 'EPR-14-X777',\n",
       " 'EPR-14-X777',\n",
       " 'EPR-14-X777',\n",
       " 'EPR-14-X892',\n",
       " 'EPR-14-X928',\n",
       " 'EPR-14-X872',\n",
       " 'EPR-14-X866',\n",
       " 'EPR-14-X866',\n",
       " 'EPR-14-X909',\n",
       " 'EPR-14-X895',\n",
       " 'EPR-14-X895',\n",
       " 'EPR-14-X895',\n",
       " 'EPR-14-X895',\n",
       " 'EPR-14-X895',\n",
       " 'EPR-14-X910',\n",
       " 'EPR-14-X915',\n",
       " 'EPR-14-X915',\n",
       " 'EPR-14-X919',\n",
       " 'EPR-14-X922',\n",
       " 'EPR-14-X922',\n",
       " 'EPR-14-X923',\n",
       " 'EPR-14-X923',\n",
       " 'EPR-14-X627',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X864',\n",
       " 'EPR-14-X850',\n",
       " 'EPR-14-X850',\n",
       " 'EPR-14-X850',\n",
       " 'EPR-14-X850',\n",
       " 'EPR-14-X863',\n",
       " 'EPR-14-X863',\n",
       " 'EPR-14-X863',\n",
       " 'EPR-14-X863',\n",
       " 'EPR-14-X924',\n",
       " 'EPR-14-X924',\n",
       " 'EPR-14-X881',\n",
       " 'EPR-14-X903',\n",
       " 'EPR-14-X920',\n",
       " 'EPR-17-X921',\n",
       " 'EPR-14-X882',\n",
       " 'EPR-14-X914',\n",
       " 'EPR-14-X890',\n",
       " 'EPR-14-X781',\n",
       " 'EPR-14-X911',\n",
       " 'EPR-14-X911',\n",
       " 'EPR-14-X911',\n",
       " 'EPR-14-X911',\n",
       " 'EPR-14-X901',\n",
       " 'EPR-14-X894',\n",
       " 'EPR-14-X907',\n",
       " 'EPR-14-X883',\n",
       " 'EPR-14-X880',\n",
       " 'EPR-14-X868',\n",
       " 'EPR-14-X879',\n",
       " 'EPR-14-X865',\n",
       " 'EPR-14-X885',\n",
       " 'EPR-14-X820',\n",
       " 'EPR-14-X770',\n",
       " 'EPR-14-X891',\n",
       " 'EPR-14-X856',\n",
       " 'EPR-14-X756',\n",
       " 'EPR-14-X756',\n",
       " 'EPR-14-X832',\n",
       " 'EPR-14-X830',\n",
       " 'EPR-14-X828',\n",
       " 'EPR-14-X827',\n",
       " 'EPR-14-X824',\n",
       " 'EPR-14-X833',\n",
       " 'EPR-14-X831',\n",
       " 'EPR-14-X829',\n",
       " 'EPR-14-X826',\n",
       " 'EPR-14-X782',\n",
       " 'EPR-14-X620',\n",
       " 'EPR-14-X849',\n",
       " 'EPR-14-X848',\n",
       " 'EPR-14-X825',\n",
       " 'EPR-14-X825',\n",
       " 'EPR-14-X798',\n",
       " 'EPR-14-X364',\n",
       " 'EPR-14-X358',\n",
       " 'EPR-14-X797',\n",
       " 'EPR-14-X884',\n",
       " 'EPR-14-X836',\n",
       " 'EPR-14-X836',\n",
       " 'EPR-14-X836',\n",
       " 'EPR-14-X773',\n",
       " 'EPR-14-X799',\n",
       " 'EPR-14-X845',\n",
       " 'EPR-14-X368',\n",
       " 'EPR-14-X368',\n",
       " 'EPR-14-X368',\n",
       " 'EPR-14-X773',\n",
       " 'EPR-14-X843',\n",
       " 'EPR-14-X741',\n",
       " 'EPR-14-X741',\n",
       " 'EPR-14-X741',\n",
       " 'EPR-14-X741',\n",
       " 'EPR-14-X763',\n",
       " 'EPR-14-X763',\n",
       " 'EPR-14-X695',\n",
       " 'EPR-14-X806',\n",
       " 'EPR-14-X472',\n",
       " 'EPR-14-X795',\n",
       " 'EPR-14-X485',\n",
       " 'EPR-14-X485',\n",
       " 'EPR-14-X485',\n",
       " 'EPR-14-X844',\n",
       " 'EPR-14-X808',\n",
       " 'EPR-14-X808',\n",
       " 'EPR-14-X808',\n",
       " 'EPR-14-X796',\n",
       " 'EPR-14-X796',\n",
       " 'EPR-14-X796',\n",
       " 'EPR-14-X810',\n",
       " 'EPR-14-X810',\n",
       " 'EPR-14-X810',\n",
       " 'EPR-14-X814',\n",
       " 'EPR-14-X819',\n",
       " 'EPR-14-X815',\n",
       " 'EPR-14-X841',\n",
       " 'EPR-14-X813',\n",
       " 'EPR-14-X811',\n",
       " 'EPR-14-X666',\n",
       " 'EPR-14-X786',\n",
       " 'EPR-14-X785',\n",
       " 'EPR-14-X784',\n",
       " 'EPR-14-X805',\n",
       " 'EPR-14-X789',\n",
       " 'EPR-14-X842',\n",
       " 'EPR-14-X842',\n",
       " 'EPR-14-X757',\n",
       " 'EPR-14-X787',\n",
       " 'EPR-14-X787',\n",
       " 'EPR-14-X787',\n",
       " 'EPR-14-X787',\n",
       " 'EPR-14-X698',\n",
       " 'EPR-14-X775',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X284',\n",
       " 'EPR-14-X838',\n",
       " 'EPR-14-X838',\n",
       " 'EPR-14-X838',\n",
       " 'EPR-14-X821',\n",
       " 'EPR-14-X821',\n",
       " 'EPR-14-X817',\n",
       " 'EPR-14-X816',\n",
       " 'EPR-14-X822',\n",
       " 'EPR-14-X809',\n",
       " 'EPR-14-X807',\n",
       " 'EPR-14-X486',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X713',\n",
       " 'EPR-14-X793',\n",
       " 'EPR-14-X764',\n",
       " 'EPR-14-X794',\n",
       " 'EPR-14-X794',\n",
       " 'EPR-14-X609',\n",
       " 'EPR-14-X609',\n",
       " 'EPR-14-X609',\n",
       " 'EPR-14-X778',\n",
       " 'EPR-14-X803',\n",
       " 'EPR-14-X769',\n",
       " 'EPR-14-X769',\n",
       " 'EPR-14-X769',\n",
       " 'EPR-14-X711',\n",
       " 'EPR-14-X790',\n",
       " 'EPR-14-X742',\n",
       " 'EPR-14-X780',\n",
       " 'EPR-14-X783',\n",
       " 'EPR-14-X804',\n",
       " 'EPR-14-X768',\n",
       " 'EPR-14-X779',\n",
       " 'EPR-14-X779',\n",
       " 'EPR-14-X779',\n",
       " 'EPR-14-X779',\n",
       " 'EPR-14-X745',\n",
       " 'EPR-14-X751',\n",
       " 'EPR-14-X746',\n",
       " 'EPR-14-X747',\n",
       " 'EPR-14-X774',\n",
       " 'EPR-14-X725',\n",
       " 'EPR-14-X499',\n",
       " 'EPR-14-X717',\n",
       " 'EPR-14-X717',\n",
       " 'EPR-14-X407',\n",
       " 'EPR-14-X407',\n",
       " 'EPR-14-X407',\n",
       " 'EPR-14-X407',\n",
       " 'EPR-14-X407',\n",
       " 'EPR-14-X378',\n",
       " 'EPR-14-X378',\n",
       " 'EPR-14-X378',\n",
       " 'EPR-14-X378',\n",
       " 'EPR-14-X378',\n",
       " 'EPR-14-X378',\n",
       " 'EPR-14-X776',\n",
       " 'EPR-14-X766',\n",
       " 'EPR-14-X730',\n",
       " 'EPR-14-X688',\n",
       " 'EPR-14-X688',\n",
       " 'EPR-14-X650',\n",
       " 'EPR-14-X772',\n",
       " 'EPR-14-X732',\n",
       " 'EPR-14-X732',\n",
       " 'EPR-14-X732',\n",
       " 'EPR-14-X732',\n",
       " 'EPR-14-X732',\n",
       " 'EPR-14-X732',\n",
       " 'EPR-14-X749',\n",
       " 'EPR-14-X740',\n",
       " 'EPR-14-X740',\n",
       " 'EPR-14-X740',\n",
       " 'EPR-14-X740',\n",
       " 'EPR-14-X760',\n",
       " 'EPR-14-X724',\n",
       " 'EPR-14-X714',\n",
       " 'EPR-14-X765',\n",
       " 'EPR-14-X744',\n",
       " 'EPR-14-X743',\n",
       " 'EPR-14-X715',\n",
       " 'EPR-14-X708',\n",
       " 'EPR-14-X683',\n",
       " 'EPR-14-X762',\n",
       " 'EPR-14-X665',\n",
       " 'EPR-14-X761',\n",
       " 'EPR-14-X714',\n",
       " 'EPR-14-X667',\n",
       " 'EPR-14-X670',\n",
       " 'EPR-14-X522',\n",
       " 'EPR-14-X750',\n",
       " 'EPR-14-X728',\n",
       " 'EPR-14-X704',\n",
       " 'EPR-14-X739',\n",
       " 'EPR-14-X735',\n",
       " 'EPR-14-X738',\n",
       " 'EPR-14-X736',\n",
       " 'EPR-14-X694',\n",
       " 'EPR-14-X694',\n",
       " 'EPR-14-X694',\n",
       " 'EPR-14-X684',\n",
       " 'EPR-14-X684',\n",
       " 'EPR-14-X700',\n",
       " 'EPR-14-X677',\n",
       " 'EPR-14-X677',\n",
       " 'EPR-14-X709',\n",
       " 'EPR-14-X733',\n",
       " 'EPR-14-X734',\n",
       " 'EPR-14-X615',\n",
       " 'EPR-14-X710',\n",
       " 'EPR-14-X698',\n",
       " 'EPR-14-X551',\n",
       " 'EPR-14-X712',\n",
       " 'EPR-14-X614',\n",
       " 'EPR-14-X614',\n",
       " 'EPR-14-X614',\n",
       " 'EPR-14-X614',\n",
       " 'EPR-14-X654',\n",
       " 'EPR-14-X653',\n",
       " 'EPR-14-X716',\n",
       " 'EPR-14-X703',\n",
       " 'EPR-14-X702',\n",
       " 'EPR-14-X729',\n",
       " 'EPR-14-X706',\n",
       " 'EPR-14-X706',\n",
       " 'EPR-14-X706',\n",
       " 'EPR-14-X706',\n",
       " 'EPR-14-X706',\n",
       " 'EPR-14-X706',\n",
       " 'EPR-14-X695',\n",
       " 'EPR-14-X652',\n",
       " 'EPR-14-X722',\n",
       " 'EPR-14-X624',\n",
       " 'EPR-14-X689',\n",
       " 'EPR-14-X658',\n",
       " 'EPR-14-X658',\n",
       " 'EPR-14-X673',\n",
       " 'EPR-14-X687',\n",
       " 'EPR-14-X686',\n",
       " 'EPR-14-X674',\n",
       " 'EPR-14-X680',\n",
       " 'EPR-14-X682',\n",
       " 'EPR-14-X672',\n",
       " 'EPR-14-X696',\n",
       " 'EPR-14-X696',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X699',\n",
       " 'EPR-14-X697',\n",
       " 'EPR-14-X697',\n",
       " 'EPR-14-X692',\n",
       " 'EPR-14-X693',\n",
       " 'EPR-14-X693',\n",
       " 'EPR-14-X693',\n",
       " 'EPR-14-X617',\n",
       " 'EPR-14-X617',\n",
       " 'EPR-14-X617',\n",
       " 'EPR-14-X617',\n",
       " 'EPR-14-X617',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X642',\n",
       " 'EPR-14-X657',\n",
       " 'EPR-14-X129',\n",
       " 'EPR-14-X623',\n",
       " 'EPR-14-X623',\n",
       " 'EPR-14-X623',\n",
       " 'EPR-14-X681',\n",
       " 'EPR-14-X679',\n",
       " 'EPR-14-X671',\n",
       " 'EPR-14-X592',\n",
       " 'EPR-14-X656',\n",
       " 'EPR-14-X655',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X455',\n",
       " 'EPR-14-X691',\n",
       " 'EPR-14-X691',\n",
       " 'EPR-14-X691',\n",
       " 'EPR-14-X691',\n",
       " 'EPR-14-X615',\n",
       " 'EPR-14-X615',\n",
       " 'EPR-14-X615',\n",
       " 'EPR-14-X641',\n",
       " 'EPR-14-X678',\n",
       " 'EPR-14-X630',\n",
       " 'EPR-14-X669',\n",
       " 'EPR-14-X637',\n",
       " 'EPR-14-X628',\n",
       " 'EPR-14-X602',\n",
       " 'EPR-14-X602',\n",
       " 'EPR-14-X602',\n",
       " 'EPR-14-X602',\n",
       " 'EPR-14-X602',\n",
       " 'EPR-14-X602',\n",
       " 'EPR-14-X640',\n",
       " 'EPR-14-X639',\n",
       " 'EPR-14-X647',\n",
       " 'EPR-14-X647',\n",
       " 'EPR-14-X576',\n",
       " 'EPR-14-X576',\n",
       " 'EPR-14-X540',\n",
       " 'EPR-14-X540',\n",
       " 'EPR-14-X540',\n",
       " 'EPR-14-X540',\n",
       " 'EPR-14-X439',\n",
       " 'EPR-14-X662',\n",
       " 'EPR-14-X634',\n",
       " 'EPR-14-X651',\n",
       " 'EPR-14-X566',\n",
       " 'EPR-14-X624',\n",
       " 'EPR-14-X588',\n",
       " 'EPR-14-X580',\n",
       " 'EPR-14-X660',\n",
       " 'EPR-14-X649',\n",
       " 'EPR-14-X636',\n",
       " 'EPR-14-X638',\n",
       " 'EPR-14-X644',\n",
       " 'EPR-14-X644',\n",
       " 'EPR-14-X646',\n",
       " 'EPR-14-X646',\n",
       " 'EPR-14-X585',\n",
       " 'EPR-14-X635',\n",
       " 'EPR-14-X599',\n",
       " 'EPR-14-X599',\n",
       " 'EPR-14-X569',\n",
       " 'EPR-14-X498',\n",
       " 'EPR-14-X632',\n",
       " 'EPR-14-X643',\n",
       " 'EPR-14-X595',\n",
       " 'EPR-14-X605',\n",
       " 'EPR-14-X619',\n",
       " 'EPR-14-X611',\n",
       " 'EPR-14-X600',\n",
       " 'EPR-14-X579',\n",
       " 'EPR-14-X613',\n",
       " 'EPR-14-X612',\n",
       " 'EPR-14-X564',\n",
       " 'EPR-14-X555',\n",
       " 'EPR-14-X591',\n",
       " 'EPR-14-X535',\n",
       " 'EPR-14-X631',\n",
       " 'EPR-14-X598',\n",
       " 'EPR-14-X526',\n",
       " 'EPR-14-X584',\n",
       " 'EPR-14-X607',\n",
       " 'EPR-14-X559',\n",
       " 'EPR-14-X557',\n",
       " 'EPR-14-X553',\n",
       " 'EPR-14-X581',\n",
       " 'EPR-14-X581',\n",
       " 'EPR-14-X581',\n",
       " 'EPR-14-X596',\n",
       " 'EPR-14-X596',\n",
       " 'EPR-14-X596',\n",
       " 'EPR-14-X596',\n",
       " 'EPR-14-X601',\n",
       " 'EPR-14-X575',\n",
       " 'EPR-14-X589',\n",
       " 'EPR-14-X589',\n",
       " 'EPR-14-X589',\n",
       " 'EPR-14-X552',\n",
       " 'EPR-14-X590',\n",
       " 'EPR-14-X204',\n",
       " 'EPR-14-X204',\n",
       " 'EPR-14-X476',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X542',\n",
       " 'EPR-14-X543',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X367',\n",
       " 'EPR-14-X577',\n",
       " 'EPR-14-X439',\n",
       " 'EPR-14-X603',\n",
       " 'EPR-14-X604',\n",
       " 'EPR-14-X594',\n",
       " 'EPR-14-X388',\n",
       " 'EPR-14-X388',\n",
       " 'EPR-14-X517',\n",
       " 'EPR-14-X517',\n",
       " 'EPR-14-X525',\n",
       " 'EPR-14-X524',\n",
       " 'EPR-14-X524',\n",
       " 'EPR-14-X587',\n",
       " 'EPR-14-X530',\n",
       " 'EPR-14-X573',\n",
       " 'EPR-14-X539',\n",
       " 'EPR-14-X539',\n",
       " 'EPR-14-X539',\n",
       " 'EPR-14-X560',\n",
       " 'EPR-14-X558',\n",
       " 'EPR-14-X554',\n",
       " 'EPR-14-X554',\n",
       " 'EPR-14-X570',\n",
       " 'EPR-14-X541',\n",
       " 'EPR-14-X538',\n",
       " 'EPR-14-X538',\n",
       " 'EPR-14-X538',\n",
       " 'EPR-14-X536',\n",
       " 'EPR-14-X536',\n",
       " 'EPR-14-X534',\n",
       " 'EPR-14-X333',\n",
       " 'EPR-14-X546',\n",
       " 'EPR-14-X546',\n",
       " 'EPR-14-X546',\n",
       " 'EPR-14-X546',\n",
       " 'EPR-14-X546',\n",
       " 'EPR-14-X546',\n",
       " 'EPR-14-X545',\n",
       " 'EPR-14-X541',\n",
       " 'EPR-14-X534',\n",
       " 'EPR-14-X538',\n",
       " 'EPR-14-X538',\n",
       " 'EPR-14-X538',\n",
       " 'EPR-14-X528',\n",
       " 'EPR-14-X532',\n",
       " 'EPR-14-X532',\n",
       " 'EPR-14-X532',\n",
       " 'EPR-14-X515',\n",
       " 'EPR-14-X547',\n",
       " 'EPR-14-X547',\n",
       " 'EPR-14-X547',\n",
       " 'EPR-14-X547',\n",
       " 'EPR-14-X514',\n",
       " 'EPR-14-X523',\n",
       " 'EPR-14-X523',\n",
       " 'EPR-14-X548',\n",
       " 'EPR-14-X522',\n",
       " 'EPR-14-X522',\n",
       " 'EPR-14-X513',\n",
       " 'EPR-14-X512',\n",
       " 'EPR-14-X451',\n",
       " 'EPR-14-X439',\n",
       " 'EPR-14-X556',\n",
       " 'EPR-14-X516',\n",
       " 'EPR-14-X519',\n",
       " 'EPR-14-X508',\n",
       " 'EPR-14-X531',\n",
       " 'EPR-14-X529',\n",
       " 'EPR-14-X529',\n",
       " 'EPR-14-X549',\n",
       " 'EPR-14-X464',\n",
       " 'EPR-14-X457',\n",
       " 'EPR-14-X448',\n",
       " 'EPR-14-X293',\n",
       " 'EPR-14-X521',\n",
       " 'EPR-14-X521',\n",
       " 'EPR-14-X509',\n",
       " 'EPR-14-X550',\n",
       " 'EPR-14-X511',\n",
       " 'EPR-14-X510',\n",
       " 'EPR-14-X430',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X491',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X459',\n",
       " 'EPR-14-X504',\n",
       " 'EPR-14-X500',\n",
       " 'EPR-14-X520',\n",
       " 'EPR-14-X484',\n",
       " ...]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "PR_list_result=[]\n",
    "for PR in PR_rawdata:\n",
    "    PR_list_result.append(get_EPR_num(PR))\n",
    "PR_list_result"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "提取EPR编号的函数创建好了之后，就可以开始调用它来处理数据了。首先建一个列表`PR_list_result`来储存处理后的数据，然后遍历`PR_rawdata`，将其中的每个元素（即包含EPR编号的字符串）传入函数`get_EPR_num()`提取EPR编号，然后存入列表`PR_list_result`。我们可以看到列表`PR_list_result`里面就是很规则的EPR编号了，共有1583个。"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1583"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(PR_list_result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "#3.在原工作表新增一列，并写入获取到的PR编号\n",
    "wb1=load_workbook(\"data\\采购信息表.xlsx\")\n",
    "ws1=wb1['Sheet1']\n",
    "i=0 #计数器，用于从包含所有EPR编号的列表PR_list_result中逐个取出数据\n",
    "for row in range(2,ws.max_row+1):\n",
    "    ws1.cell(row=row,column=5).value=PR_list_result[i]\n",
    "    i+=1 #计数器加1，以提取下一个数据\n",
    "wb1.save(\"data\\采购信息表_新.xlsx\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "数据处理完后，就可以写入到Excel表里面去了。我们在原表中最后一列的后面写入规整的EPR编号。所以还是先打开“采购信息表.xlsx”，获取工作表“Sheet1”。定义一个计数器i，将其作为索引用于从包含所有EPR编号的列表PR_list_result中逐个取出数据，其初始值为0，因为列表的索引是从0开始的。然后建立一个`for`循环，从Excel表的第二行，第5列开始写入数据，写一个数据，计数器i加上1，以便写入下一个数据。\n",
    "\n",
    "数据写完后，使用新的文件名保存文件。最后得到的结果如下：\n",
    "![](images\\result.png)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
